﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_BBS_DeleteBoardMaster]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_BBS_DeleteBoardMaster];
GO
CREATE PROCEDURE [dbo].[sproc_BBS_DeleteBoardMaster]
    @BoardID int,
    @StaffID int
/*

===================================================
功能:    删除版主
参数:
    @BoardID     :    版块ID
    @StaffID     :    员工ID

===================================================

*/
AS
    DELETE FROM  uds_bbs_boardmaster WHERE board_id = @boardid and staff_id = @staffid